The following instruction guides you through the process of setting up a structure synchronization. Customize options according to your needs.
Related topic:
Data Synchronization
Source
Defines connection and schema for the source.
Target
Defines connection and schema for the target.
Compare Options
Compare tables
Check this option if you want to compare tables between the source and target schemas. Select/unselect the eight options below:
Compare primary keys
Check this option if you want to compare table primary keys.
Compare indexes
Check this option if you want to compare indexes.
Compare foreign keys
Check this option if you want to compare table foreign keys.
Compare uniques
Check this option if you want to compare uniques.
Compare checks
Check this option if you want to compare checks.
Compare rules
Check this option if you want to compare rules.
Compare excludes
Check this option if you want to compare exclude constraints.
Compare triggers
Check this option if you want to compare triggers.
Compare views
Check this option if you want to compare views.
Compare functions
Check this option if you want to compare functions.
Compare sequences
Check this option if you want to compare sequences.
Execution Options
SQL for objects to be created
Check this option if you want to create new objects in the target schema.
SQL for objects to be changed
Check this option if you want to modify object structures in the target schema.
SQL for objects to be dropped
Check this option if you want to remove objects, which do not exist in the source schema, from the target schema.
Drop with cascade
Check this option if you want to drop objects with cascade.
Compare after execution
Compares tables after the synchronization is executed.
Continue on error
Ignores errors that are encountered during the synchronization process.